<?php

namespace Classes;

use Classes\db\DBConnection;
use PDO;
use Exception;

class City {
	public static function getCity($city_id) {
		$connection = DBConnection::getDBConnection ();
		
		$statement = "SELECT *
						FROM `city`
						WHERE city_id=:CITY_ID";
		$stmt = $connection->prepare ( $statement );
		$stmt->bindValue ( ":CITY_ID", $city_id, \PDO::PARAM_INT );
		$stmt->execute ();
		$result = $stmt->fetchAll ();
		return $result[0];
	}
}